/*
 Navicat Premium Data Transfer

 Source Server         : 个人_本机
 Source Server Type    : MySQL
 Source Server Version : 50720
 Source Host           : localhost:3306
 Source Schema         : semptian_ms

 Target Server Type    : MySQL
 Target Server Version : 50720
 File Encoding         : 65001

 Date: 19/07/2022 10:04:18
*/

SET NAMES utf8mb4;
SET
FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for stock_order
-- ----------------------------
DROP TABLE IF EXISTS `stock_order`;
CREATE TABLE `stock_order`
(
    `id`          bigint(20) NOT NULL COMMENT '主键id',
    `sid`         bigint(20) DEFAULT NULL COMMENT '库存id',
    `name`        varchar(60) DEFAULT NULL COMMENT '商品名称',
    `create_time` bigint(13) DEFAULT NULL COMMENT '创建时间',
    `update_time` bigint(13) DEFAULT NULL COMMENT '更新时间',
    `candelete`   tinyint(1) DEFAULT NULL COMMENT '删除状态：0未删除；1删除',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of stock_order
-- ----------------------------
BEGIN;
INSERT INTO `stock_order` (`id`, `sid`, `name`, `create_time`, `update_time`, `candelete`)
VALUES (1, 1, 'iphone手机', NULL, NULL, 0);
COMMIT;

SET
FOREIGN_KEY_CHECKS = 1;
